DBC-Zorgproducten per jaar, specialisme, diagnose

Dataset statistics

Number of variables	14
Number of observations	321434
Missing cells	48654
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	34.3 MiB
Average record size in memory	112.0 B

Variable types

Categorical	4
DateTime	1
Numeric	9

Alerts

`VERSIE` has constant value ""	Constant
`DATUM_BESTAND` has constant value ""	Constant
`PEILDATUM` has constant value ""	Constant
`TYPERENDE_DIAGNOSE_CD` has a high cardinality: 1899 distinct values	High cardinality
`BEHANDELEND_SPECIALISME_CD` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`AANTAL_PAT_PER_ZPD` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_ZPD`	High correlation
`AANTAL_SUBTRAJECT_PER_ZPD` is highly overall correlated with `AANTAL_PAT_PER_ZPD`	High correlation
`AANTAL_PAT_PER_DIAG` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_DIAG`	High correlation
`AANTAL_SUBTRAJECT_PER_DIAG` is highly overall correlated with `AANTAL_PAT_PER_DIAG`	High correlation
`AANTAL_PAT_PER_SPC` is highly overall correlated with `BEHANDELEND_SPECIALISME_CD` and 1 other fields	High correlation
`AANTAL_SUBTRAJECT_PER_SPC` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`GEMIDDELDE_VERKOOPPRIJS` has 48654 (15.1%) missing values	Missing
`AANTAL_SUBTRAJECT_PER_ZPD` is highly skewed (γ1 = 21.09481489)	Skewed

Reproduction

Analysis started	2023-03-28 08:14:46.667076
Analysis finished	2023-03-28 08:15:08.469658
Duration	21.8 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

VERSIE
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

1.0	321434

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	964302
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	321434	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	321434	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	321434	33.3%
.	321434	33.3%
0	321434	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	642868	66.7%
Other Punctuation	321434	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	321434	50.0%
0	321434	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	321434	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	964302	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	321434	33.3%
.	321434	33.3%
0	321434	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	964302	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	321434	33.3%
.	321434	33.3%
0	321434	33.3%

DATUM_BESTAND
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

2023-03-10	321434

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3214340
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-03-10
2nd row	2023-03-10
3rd row	2023-03-10
4th row	2023-03-10
5th row	2023-03-10

Common Values

Value	Count	Frequency (%)
2023-03-10	321434	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-03-10	321434	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	964302	30.0%
2	642868	20.0%
3	642868	20.0%
-	642868	20.0%
1	321434	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2571472	80.0%
Dash Punctuation	642868	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	964302	37.5%
2	642868	25.0%
3	642868	25.0%
1	321434	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	642868	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3214340	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	964302	30.0%
2	642868	20.0%
3	642868	20.0%
-	642868	20.0%
1	321434	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3214340	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	964302	30.0%
2	642868	20.0%
3	642868	20.0%
-	642868	20.0%
1	321434	10.0%

PEILDATUM
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

2023-03-01	321434

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3214340
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-03-01
2nd row	2023-03-01
3rd row	2023-03-01
4th row	2023-03-01
5th row	2023-03-01

Common Values

Value	Count	Frequency (%)
2023-03-01	321434	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-03-01	321434	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	964302	30.0%
2	642868	20.0%
3	642868	20.0%
-	642868	20.0%
1	321434	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2571472	80.0%
Dash Punctuation	642868	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	964302	37.5%
2	642868	25.0%
3	642868	25.0%
1	321434	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	642868	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3214340	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	964302	30.0%
2	642868	20.0%
3	642868	20.0%
-	642868	20.0%
1	321434	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3214340	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	964302	30.0%
2	642868	20.0%
3	642868	20.0%
-	642868	20.0%
1	321434	10.0%

JAAR
Date

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

Minimum	2012-01-01 00:00:00
Maximum	2023-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=12)

BEHANDELEND_SPECIALISME_CD
Real number (ℝ)

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	438.46217

Minimum	301
Maximum	8418
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	301
5-th percentile	302
Q1	305
median	313
Q3	322
95-th percentile	335
Maximum	8418
Range	8117
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	990.3148
Coefficient of variation (CV)	2.2586095
Kurtosis	60.821646
Mean	438.46217
Median Absolute Deviation (MAD)	8
Skewness	7.9205314
Sum	1.4093665 × 10⁸
Variance	980723.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
305	45451	14.1%
313	41599	12.9%
303	37029	11.5%
330	25407	7.9%
316	21881	6.8%
308	17400	5.4%
306	13484	4.2%
324	13276	4.1%
301	12850	4.0%
304	10414	3.2%
Other values (18)	82643	25.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
301	12850	4.0%
302	7028	2.2%
303	37029	11.5%
304	10414	3.2%
305	45451	14.1%
306	13484	4.2%
307	5607	1.7%
308	17400	5.4%
310	3502	1.1%
313	41599	12.9%

Value	Count	Frequency (%)
8418	4291	1.3%
8416	576	0.2%
1900	210	0.1%
390	864	0.3%
389	3397	1.1%
362	4328	1.3%
361	2313	0.7%
335	3243	1.0%
330	25407	7.9%
329	835	0.3%

TYPERENDE_DIAGNOSE_CD
Categorical

Distinct	1899
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

101	1363
402	1314
301	1285
403	1282
201	1209
Other values (1894)	314981

Length

Max length	4
Median length	3
Mean length	3.3529838
Min length	2

Characters and Unicode

Total characters	1077763
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18 ?
Unique (%)	< 0.1%

Sample

1st row	19
2nd row	19
3rd row	19
4th row	03
5th row	03

Common Values

Value	Count	Frequency (%)
101	1363	0.4%
402	1314	0.4%
301	1285	0.4%
403	1282	0.4%
201	1209	0.4%
203	1204	0.4%
401	1071	0.3%
404	1065	0.3%
802	1047	0.3%
409	1035	0.3%
Other values (1889)	309559	96.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
101	1363	0.4%
402	1314	0.4%
301	1285	0.4%
403	1282	0.4%
201	1209	0.4%
203	1204	0.4%
401	1071	0.3%
404	1065	0.3%
802	1047	0.3%
409	1035	0.3%
Other values (1889)	309559	96.3%

Most occurring characters

Value	Count	Frequency (%)
1	206266	19.1%
0	197520	18.3%
2	142905	13.3%
3	116689	10.8%
5	83168	7.7%
9	77631	7.2%
4	76369	7.1%
7	63516	5.9%
6	56364	5.2%
8	46439	4.3%
Other values (15)	10896	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1066867	99.0%
Uppercase Letter	10896	1.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	2022	18.6%
M	1844	16.9%
B	1306	12.0%
E	920	8.4%
Z	915	8.4%
D	731	6.7%
A	707	6.5%
F	679	6.2%
C	361	3.3%
K	350	3.2%
Other values (5)	1061	9.7%

Decimal Number

Value	Count	Frequency (%)
1	206266	19.3%
0	197520	18.5%
2	142905	13.4%
3	116689	10.9%
5	83168	7.8%
9	77631	7.3%
4	76369	7.2%
7	63516	6.0%
6	56364	5.3%
8	46439	4.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	1066867	99.0%
Latin	10896	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	2022	18.6%
M	1844	16.9%
B	1306	12.0%
E	920	8.4%
Z	915	8.4%
D	731	6.7%
A	707	6.5%
F	679	6.2%
C	361	3.3%
K	350	3.2%
Other values (5)	1061	9.7%

Common

Value	Count	Frequency (%)
1	206266	19.3%
0	197520	18.5%
2	142905	13.4%
3	116689	10.9%
5	83168	7.8%
9	77631	7.3%
4	76369	7.2%
7	63516	6.0%
6	56364	5.3%
8	46439	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1077763	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	206266	19.1%
0	197520	18.3%
2	142905	13.3%
3	116689	10.8%
5	83168	7.7%
9	77631	7.2%
4	76369	7.1%
7	63516	5.9%
6	56364	5.2%
8	46439	4.3%
Other values (15)	10896	1.0%

ZORGPRODUCT_CD
Real number (ℝ)

Distinct	6031
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4246152 × 10⁸

Minimum	10501002
Maximum	9.9841808 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	10501002
5-th percentile	28999040
Q1	99899013
median	1.49899 × 10⁸
Q3	9.90004 × 10⁸
95-th percentile	9.9051604 × 10⁸
Maximum	9.9841808 × 10⁸
Range	9.8791708 × 10⁸
Interquartile range (IQR)	8.9010499 × 10⁸

Descriptive statistics

Standard deviation	4.2936081 × 10⁸
Coefficient of variation (CV)	0.9703913
Kurtosis	-1.7450632
Mean	4.4246152 × 10⁸
Median Absolute Deviation (MAD)	1.2 × 10⁸
Skewness	0.45955627
Sum	1.4222218 × 10¹⁴
Variance	1.8435071 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
990004009	2325	0.7%
990004007	2290	0.7%
990003004	2253	0.7%
990004006	1874	0.6%
990356076	1692	0.5%
990356073	1569	0.5%
131999228	1493	0.5%
131999164	1476	0.5%
990003007	1466	0.5%
131999194	1354	0.4%
Other values (6021)	303642	94.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10501002	9	< 0.1%
10501003	11	< 0.1%
10501004	11	< 0.1%
10501005	11	< 0.1%
10501007	3	< 0.1%
10501008	11	< 0.1%
10501010	11	< 0.1%
10501011	3	< 0.1%
11101002	10	< 0.1%
11101003	11	< 0.1%

Value	Count	Frequency (%)
998418081	162	0.1%
998418080	146	< 0.1%
998418079	38	< 0.1%
998418077	8	< 0.1%
998418076	8	< 0.1%
998418075	7	< 0.1%
998418074	214	0.1%
998418073	215	0.1%
998418072	8	< 0.1%
998418071	8	< 0.1%

AANTAL_PAT_PER_ZPD
Real number (ℝ)

Distinct	10202
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	523.6785

Minimum	1
Maximum	165140
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	14
Q3	106
95-th percentile	1784
Maximum	165140
Range	165139
Interquartile range (IQR)	103

Descriptive statistics

Standard deviation	3211.7908
Coefficient of variation (CV)	6.1331348
Kurtosis	396.07661
Mean	523.6785
Median Absolute Deviation (MAD)	13
Skewness	16.485649
Sum	1.6832807 × 10⁸
Variance	10315600
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	52710	16.4%
2	25846	8.0%
3	16873	5.2%
4	12351	3.8%
5	9682	3.0%
6	8231	2.6%
7	6820	2.1%
8	5755	1.8%
9	5209	1.6%
10	4692	1.5%
Other values (10192)	173265	53.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	52710	16.4%
2	25846	8.0%
3	16873	5.2%
4	12351	3.8%
5	9682	3.0%
6	8231	2.6%
7	6820	2.1%
8	5755	1.8%
9	5209	1.6%
10	4692	1.5%

Value	Count	Frequency (%)
165140	1	< 0.1%
162004	1	< 0.1%
155884	1	< 0.1%
154269	1	< 0.1%
154268	1	< 0.1%
144724	1	< 0.1%
118397	1	< 0.1%
115938	1	< 0.1%
112534	1	< 0.1%
111204	1	< 0.1%

AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	10907
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	619.17139

Minimum	1
Maximum	240002
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	15
Q3	116
95-th percentile	2035
Maximum	240002
Range	240001
Interquartile range (IQR)	113

Descriptive statistics

Standard deviation	4133.9611
Coefficient of variation (CV)	6.6766023
Kurtosis	708.09274
Mean	619.17139
Median Absolute Deviation (MAD)	14
Skewness	21.094815
Sum	1.9902274 × 10⁸
Variance	17089635
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	50712	15.8%
2	25400	7.9%
3	16709	5.2%
4	12147	3.8%
5	9582	3.0%
6	8203	2.6%
7	6808	2.1%
8	5691	1.8%
9	5190	1.6%
10	4660	1.4%
Other values (10897)	176332	54.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	50712	15.8%
2	25400	7.9%
3	16709	5.2%
4	12147	3.8%
5	9582	3.0%
6	8203	2.6%
7	6808	2.1%
8	5691	1.8%
9	5190	1.6%
10	4660	1.4%

Value	Count	Frequency (%)
240002	1	< 0.1%
232423	1	< 0.1%
231954	1	< 0.1%
231005	1	< 0.1%
227936	1	< 0.1%
227409	1	< 0.1%
226301	1	< 0.1%
223939	1	< 0.1%
218673	1	< 0.1%
215068	1	< 0.1%

AANTAL_PAT_PER_DIAG
Real number (ℝ)

Distinct	9109
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7853.645

Minimum	1
Maximum	230106
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	43
Q1	421
median	1772
Q3	6583
95-th percentile	37339
Maximum	230106
Range	230105
Interquartile range (IQR)	6162

Descriptive statistics

Standard deviation	18053.237
Coefficient of variation (CV)	2.298708
Kurtosis	33.416809
Mean	7853.645
Median Absolute Deviation (MAD)	1608
Skewness	5.0070463
Sum	2.5244285 × 10⁹
Variance	3.2591936 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	494	0.2%
25	476	0.1%
17	466	0.1%
9	452	0.1%
30	449	0.1%
8	442	0.1%
14	439	0.1%
19	437	0.1%
12	429	0.1%
26	426	0.1%
Other values (9099)	316924	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	376	0.1%
2	404	0.1%
3	383	0.1%
4	379	0.1%
5	405	0.1%
6	389	0.1%
7	373	0.1%
8	442	0.1%
9	452	0.1%
10	346	0.1%

Value	Count	Frequency (%)
230106	23	< 0.1%
227966	23	< 0.1%
217955	24	< 0.1%
214513	17	< 0.1%
213535	25	< 0.1%
211593	17	< 0.1%
210432	19	< 0.1%
205347	17	< 0.1%
200603	16	< 0.1%
198527	20	< 0.1%

AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)

Distinct	10147
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11332.51

Minimum	1
Maximum	370022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	55
Q1	558
median	2468
Q3	9334
95-th percentile	53129
Maximum	370022
Range	370021
Interquartile range (IQR)	8776

Descriptive statistics

Standard deviation	26933.457
Coefficient of variation (CV)	2.3766543
Kurtosis	36.968916
Mean	11332.51
Median Absolute Deviation (MAD)	2259
Skewness	5.2530899
Sum	3.6426539 × 10⁹
Variance	7.2541112 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25	374	0.1%
17	363	0.1%
52	362	0.1%
39	353	0.1%
19	352	0.1%
24	346	0.1%
38	344	0.1%
18	340	0.1%
11	339	0.1%
23	338	0.1%
Other values (10137)	317923	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	294	0.1%
2	306	0.1%
3	317	0.1%
4	297	0.1%
5	314	0.1%
6	324	0.1%
7	328	0.1%
8	271	0.1%
9	267	0.1%
10	302	0.1%

Value	Count	Frequency (%)
370022	23	< 0.1%
364051	23	< 0.1%
348522	25	< 0.1%
343312	24	< 0.1%
341691	19	< 0.1%
323791	20	< 0.1%
315783	17	< 0.1%
310778	17	< 0.1%
298646	17	< 0.1%
292753	16	< 0.1%

AANTAL_PAT_PER_SPC
Real number (ℝ)

Distinct	308
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	684619.67

Minimum	1
Maximum	1487636
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	43722
Q1	355515
median	764932
Q3	1026475
95-th percentile	1340740
Maximum	1487636
Range	1487635
Interquartile range (IQR)	670960

Descriptive statistics

Standard deviation	409428.45
Coefficient of variation (CV)	0.59803781
Kurtosis	-1.0740056
Mean	684619.67
Median Absolute Deviation (MAD)	316122
Skewness	-0.053160846
Sum	2.2006004 × 10¹¹
Variance	1.6763165 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
880937	5102	1.6%
874110	4354	1.4%
843981	4347	1.4%
894322	4333	1.3%
880489	4273	1.3%
897718	4212	1.3%
764932	4089	1.3%
802099	4026	1.3%
1081075	3890	1.2%
1100224	3866	1.2%
Other values (298)	278942	86.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	< 0.1%
2	3	< 0.1%
3	4	< 0.1%
9	1	< 0.1%
10	3	< 0.1%
13	4	< 0.1%
17	5	< 0.1%
28	24	< 0.1%
44	2	< 0.1%
146	10	< 0.1%

Value	Count	Frequency (%)
1487636	2975	0.9%
1450401	3048	0.9%
1421736	3564	1.1%
1344428	3543	1.1%
1340740	3441	1.1%
1332404	3545	1.1%
1316540	3463	1.1%
1282947	3576	1.1%
1266251	3351	1.0%
1265245	1177	0.4%

AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)

Distinct	309
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1106103.5

Minimum	1
Maximum	2665360
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	47348
Q1	512567
median	1129373
Q3	1760849
95-th percentile	2549091
Maximum	2665360
Range	2665359
Interquartile range (IQR)	1248282

Descriptive statistics

Standard deviation	734533.15
Coefficient of variation (CV)	0.66407272
Kurtosis	-0.77331992
Mean	1106103.5
Median Absolute Deviation (MAD)	624409
Skewness	0.3284368
Sum	3.5553927 × 10¹¹
Variance	5.3953895 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1211796	5102	1.6%
1281512	4354	1.4%
1216262	4347	1.4%
1315589	4333	1.3%
1300454	4273	1.3%
1341867	4212	1.3%
1155560	4089	1.3%
1201838	4026	1.3%
2549091	3890	1.2%
2665360	3866	1.2%
Other values (299)	278942	86.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	< 0.1%
2	3	< 0.1%
3	4	< 0.1%
9	1	< 0.1%
10	3	< 0.1%
16	4	< 0.1%
17	5	< 0.1%
28	22	< 0.1%
29	2	< 0.1%
44	2	< 0.1%

Value	Count	Frequency (%)
2665360	3866	1.2%
2659078	3796	1.2%
2619966	3788	1.2%
2594527	3844	1.2%
2549091	3890	1.2%
2480797	3851	1.2%
2179106	3757	1.2%
2062587	3811	1.2%
2052315	1168	0.4%
1990256	1167	0.4%

GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)

Distinct	3535
Distinct (%)	1.3%
Missing	48654
Missing (%)	15.1%
Infinite	0
Infinite (%)	0.0%
Mean	3588.0168

Minimum	70
Maximum	287220
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	70
5-th percentile	140
Q1	480
median	1260
Q3	4190
95-th percentile	13620
Maximum	287220
Range	287150
Interquartile range (IQR)	3710

Descriptive statistics

Standard deviation	6532.4671
Coefficient of variation (CV)	1.8206345
Kurtosis	145.57442
Mean	3588.0168
Median Absolute Deviation (MAD)	1030
Skewness	7.1813867
Sum	9.7873922 × 10⁸
Variance	42673126
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
160	2009	0.6%
105	1938	0.6%
110	1790	0.6%
180	1565	0.5%
185	1551	0.5%
300	1439	0.4%
145	1386	0.4%
175	1364	0.4%
120	1335	0.4%
165	1276	0.4%
Other values (3525)	257127	80.0%
(Missing)	48654	15.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
70	226	0.1%
75	75	< 0.1%
80	362	0.1%
85	919	0.3%
90	689	0.2%
95	695	0.2%
100	924	0.3%
105	1938	0.6%
110	1790	0.6%
115	1093	0.3%

Value	Count	Frequency (%)
287220	8	< 0.1%
148910	3	< 0.1%
142835	4	< 0.1%
122155	4	< 0.1%
116805	3	< 0.1%
109725	7	< 0.1%
108570	7	< 0.1%
107655	4	< 0.1%
101270	8	< 0.1%
96945	5	< 0.1%

Auto

Heatmap
Table

	BEHANDELEND_SPECIALISME_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
BEHANDELEND_SPECIALISME_CD	1.000	0.217	0.008	0.013	-0.061	-0.054	-0.562	-0.483	0.049
ZORGPRODUCT_CD	0.217	1.000	-0.142	-0.150	-0.180	-0.212	-0.385	-0.415	0.027
AANTAL_PAT_PER_ZPD	0.008	-0.142	1.000	0.996	0.322	0.320	0.068	0.078	-0.304
AANTAL_SUBTRAJECT_PER_ZPD	0.013	-0.150	0.996	1.000	0.319	0.321	0.071	0.085	-0.306
AANTAL_PAT_PER_DIAG	-0.061	-0.180	0.322	0.319	1.000	0.987	0.310	0.293	0.025
AANTAL_SUBTRAJECT_PER_DIAG	-0.054	-0.212	0.320	0.321	0.987	1.000	0.323	0.323	0.033
AANTAL_PAT_PER_SPC	-0.562	-0.385	0.068	0.071	0.310	0.323	1.000	0.961	-0.013
AANTAL_SUBTRAJECT_PER_SPC	-0.483	-0.415	0.078	0.085	0.293	0.323	0.961	1.000	-0.016
GEMIDDELDE_VERKOOPPRIJS	0.049	0.027	-0.304	-0.306	0.025	0.033	-0.013	-0.016	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
0	1.0	2023-03-10	2023-03-01	2018-01-01	329	19	59899065	102	131	152	285	21981	24168	NaN
1	1.0	2023-03-10	2023-03-01	2018-01-01	329	19	59899066	137	142	152	285	21981	24168	NaN
2	1.0	2023-03-10	2023-03-01	2018-01-01	329	19	59899067	11	12	152	285	21981	24168	1440.0
3	1.0	2023-03-10	2023-03-01	2018-01-01	329	03	990029011	375	379	847	863	21981	24168	545.0
4	1.0	2023-03-10	2023-03-01	2018-01-01	329	03	990029012	242	243	847	863	21981	24168	1040.0
5	1.0	2023-03-10	2023-03-01	2018-01-01	329	03	990029002	58	58	847	863	21981	24168	205.0
6	1.0	2023-03-10	2023-03-01	2018-01-01	329	03	990029010	179	183	847	863	21981	24168	1345.0
7	1.0	2023-03-10	2023-03-01	2018-01-01	329	05	990029002	120	124	1285	1346	21981	24168	205.0
8	1.0	2023-03-10	2023-03-01	2018-01-01	329	05	990029011	594	605	1285	1346	21981	24168	545.0
9	1.0	2023-03-10	2023-03-01	2018-01-01	329	05	990029010	256	261	1285	1346	21981	24168	1345.0

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
321424	1.0	2023-03-10	2023-03-01	2017-01-01	361	111	990061001	2	2	752	1068	88322	128548	NaN
321425	1.0	2023-03-10	2023-03-01	2017-01-01	361	111	990061014	32	32	752	1068	88322	128548	1340.0
321426	1.0	2023-03-10	2023-03-01	2017-01-01	361	111	990061066	13	14	752	1068	88322	128548	3970.0
321427	1.0	2023-03-10	2023-03-01	2017-01-01	361	111	990061004	1	1	752	1068	88322	128548	NaN
321428	1.0	2023-03-10	2023-03-01	2017-01-01	361	111	990061068	2	2	752	1068	88322	128548	4775.0
321429	1.0	2023-03-10	2023-03-01	2017-01-01	361	111	990061070	33	33	752	1068	88322	128548	9950.0
321430	1.0	2023-03-10	2023-03-01	2017-01-01	361	111	990061067	289	406	752	1068	88322	128548	1660.0
321431	1.0	2023-03-10	2023-03-01	2017-01-01	361	111	990061072	197	211	752	1068	88322	128548	6845.0
321432	1.0	2023-03-10	2023-03-01	2017-01-01	361	111	990061008	22	24	752	1068	88322	128548	7255.0
321433	1.0	2023-03-10	2023-03-01	2017-01-01	361	111	990061018	56	58	752	1068	88322	128548	300.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample